package com.zygh.policeasset.mapper;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/* loaded from: police-asset-2.0-0.0.1-SNAPSHOT.jar:BOOT-INF/classes/com/zygh/policeasset/mapper/ProjectAssetsBusinessMapper.class */
public interface ProjectAssetsBusinessMapper {
    @Select({"SELECT  count(*)  FROM   assets a  LEFT JOIN settlement s ON s.project_no = a.build_num   AND s.section_id = a.section_id  LEFT JOIN project_assets_business pb ON pb.settlement_id = s.id \nWHERE pb.flow_no = #{flowNo}"})
    Integer queryByFlowNo(String str);

    @Insert({"insert into project_assets_business(settlement_id,flow_no)values(#{settlementId},#{flowNo} )"})
    int insert(@Param("settlementId") Integer num, @Param("flowNo") String str);
}